<%-- 
    Document   : StoreLogin
    Created on : Jun 4, 2012, 11:19:39 AM
    Author     : praneeth
--%>
<%@page import="java.sql.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Store Login JSP Page</title>
    </head>
    <body>    <h1>Thankyou....</h1>
         
        
        <%
        
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String uid=request.getParameter("uid");
            String pwd=request.getParameter("pwd");
            String role=request.getParameter("role");
            String hq=request.getParameter("hq");
            String ha=request.getParameter("ha");
            
            String q1="insert into Login values('"+uid+"','"+pwd+"','"+role+"','"+hq+"','"+ha+"')";
            System.out.println(q1);
            
        Connection connection=DriverManager.getConnection("jdbc:odbc:egasdsn");
        Statement stmt =connection.createStatement();
       
        int rs=stmt.executeUpdate(q1);
            
           // out.println(q1+"  "+rs);
            if(rs==1)
                out.println("You are Acc holder member ");
        
        %>
    </body>
</html>
